/***********************************************************
* Purpose : insert User_Account
* Author : DATDT
* Date: 25/3/2012
* Description: insert account
*/
IF exists (SELECT * FROM dbo.sysobjects WHERE NAME = 'sp_insertUser_Account')
	DROP PROC sp_insertUser_Account
GO
CREATE PROC sp_insertUser_Account

	@Role_ID INTEGER,
    @Username VARCHAR(50),
    @Password VARCHAR(50),
    @Name VARCHAR(50),
    @Phone_No INTEGER,
    @Email VARCHAR(100),
    @Ammount FLOAT,
    @Last_Played DATETIME
AS
BEGIN
	DECLARE @Last_Update DATETIME
	SET @Last_Update = GETDATE()

	INSERT INTO User_Account VALUES (@Role_ID, @Username, @Password, @Name, @Phone_No, @Email, @Ammount, @Last_Played, @Last_Update)
END